Reporting Services Configuration Manager is throwing an error when I try to "Find" the server. The manager starts up and takes me to the "Reporting Services Configuration Connection" window. I click on the "Find" button (leaving the default comptuer name as-is; the local machine)  and get the error message "Invalid Class" with the title "Reporting Services Configuration Manager".

I've been searching around the interner and only found one forum post with a similar problem to my own. It was on this forum and the advice seemed to be pointing towards a problem with WMI, but it seemed that the user never found a solution. I've downloaded and ran the WMI diagnostics program and the log does contain quite a few warnings, but I don't know how to go about solving most of them. I did run regsvr32 on some dll files though :)

I won't post any logs yet, as I have no idea where the problem may be based. Please advise and I will post the required information.

This is a common problem with you install 2005 and 2008 on the same server.  Is SSRS 2008 the only installation that is currently installed?

Nope, I do have 2005 installed aswell.

I suppose I don't actually need them both installed though... It just taken me a while to get the two versions that I'm not sure about playing with the installations. hehe

If I were to remove 2005, would it require me to remove the entire installation of SQL Server 2005 or just the SSRS part of it?
Also, do you happen to know if removing 2005 (be it the entire thing or just SSRS) would solve the problem without me needing to manually edit config files etc?

Thanks for the response onpnt

• Edited by SiM99 Monday, January 18, 2010 1:43 PM Updated the question to be more specific.

Hi,

I have SSRS 2005 AND SSRS 2008 installed on the same server, but I never faced that problem.
Not sure having both version installed is linked to that issue.

Amaury.

Not sure having both version installed is linked to that issue.

You never know Amaury - I'm sure that SQL Server and SSRS have lots of settings and certain things may only be changed under certain circumstances.

That's why I wrote "Not Sure" ;-)

Hi SiM99,

The issue shoule be caused by the case onpnt mentioned and you are trying to use Reporting Services Configuration Manager 2008 to connect to Reporting Services 2005. From your post, I am sure you never install SQL Server 2005 in the server. But, sometimes, SQL Server Express 2005 may be installed with other program. So, I would suggest you checking if SQL Server Expree 2005 is installed in the server using Services control(by running command services.msc). If SQL Server Express 2005 is installed, please uninstall it.

The issue should be caused by the uncompleted installation too. There may be a error during the installation.

Could you please check if there is any error in the installation error message?
By default, we can get the installation logs from:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Log\Summary.txt

By the way, could you please follow these steps to check if the Reporting Services WMI provider is installed correctly?
1. Run command wbemtest
2. Click "Connect"and connect to “ROOT\Microsoft\SqlServer\ReportServer”(type this path in the Namespace textbox)
3. After connecting to the name space, click "Query" to query “SELECT * from __namespace”. There would be one data in the record window(while the server only have one RS instance).
4. Double-click the record, in the new properties windows, get the path value such as “\\<server>\ROOT\Microsoft\SqlServer\ReportServer:__NAMESPACE.Name="RS_MSSQLSERVER" ”
5. Now, close all sub dialogs, and then re-connect to “ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER”. "RS_MSSQLSERVER"  is the Namespace.Name in step4
6. Query “SELECT * from __namespace” again.
7. Repeat step4,5, we will get the new path “ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10”
8. Repeat step2 to 7 until there is no record in the Query result dialog. Finally, the path is \\server\ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\admin

If we can't get the final path \\server\ROOT\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\admin, it means the Reporting Services WMI provider is not installed correctly.

Please try using the following method to solve it:
1.Execute the Command windows.
2.Go to the folder C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\bin
3.Run the command: MOFCOMP reportingservices.mof

Please feel free to ask, if you have any more questions.

Thanks,
Jin Chen

Installing SP1 would resolve the issue.

Hi,

Install SP1 in the sense of SQL server 2008 SP1?

 

I have a similar issue but with SQL Server 2008 R2.  SSRS Configuration Manager is throwing an "invalid class" error when I try to connect to the server and hit "find".

The server is a virtual server with minimal resources running Windows Server 2008R2 Standard, the only software installed on the server is SSRS (the databases live on our SQL cluster).

SQL version is 10.50.1600 on both the SSRS instance and the SQL cluster.

I have the following error associated with the SSRS Service:
"Failed to unload app domain DefaultDomain. The following exception occurred: Error while unloading appdomain. (Exception from HRESULT: 0x80131015)."

I looked at your reply above:

• There are no errors in the installation logs.
• using WMI I get the error "Invalid Class" when I execute the query.
• Running MOFCOMP had no obvious effect, but ran without error.

Do you have any suggestions with regards to sorting this out?

Regards,

Bill

 

 

 

My issue was caused by a second instance of SSRS on the server not working correctly.  Removing the (no longer requried) faulty instance resolved my issue.

This response was by far the most interesting approach. It did help me identify that I indeed had an issue. I was not able to fix anything this way though.

My issue was because I installed SSRS from the SQL 2012 Express with Advanced Services... the 2012 SSRS worked great but I could not use the SSRS 2008 R2 (Developer Edition). I had to uninstall SSRS 2012.

I have noticed that this issue can be caused by not running the configuration manager as Administrator, it the default login does not have the required WMI access.

Right click the Reporting Services Configuration Manager and choose Run As Administrator.

If you do not have administrative access then you might need to have the permissions elevated for WMI access to the login that you are using

David Bridge

David Bridge Technology Limited

Bill,,

I am experiencing a very similar issue to what you have posted.

In the end what was your solution?  Were you able to get RS Configuration Manager connected to the Reporting Services Instance?

Thanks

Trevor

I'm having a similar problem with my 2008 R2 installation.  

* The WMI is installed correctly

* The MOF script runs successfully with no change to the error

* I've restarted the services and the server and re-installed the instance.(The account used is an admin account)

There is a 2005 installation on the machine but there is no SSRS installed along with it.  So I'm not sure if uninstalling this will actually help.  Does anyone have any new ideas on this?  Is Jinchun Chen still active to assist with this?

Joe P.

• Proposed as answer by JPPearce Wednesday, September 24, 2014 8:33 PM
• Unproposed as answer by JPPearce Wednesday, September 24, 2014 8:33 PM

I had some help from Microsoft support solving this issue and wanted to post the solution if anyone else runs into the problem I had.

I had SSRS on my local machine and the server, it was causing the error on the server.  It turns out the Report Servers from my machine were listed in the WMI list with a prefix of RS_.  Deleting my machine's Report Servers from the list solved this problem.

• Proposed as answer by JPPearce Wednesday, September 24, 2014 8:37 PM

Can you please tell me how you were able to look at the WMI List and how did you delete the specifc entry, any particular script to do that ?

Thanks,

Sudhir